dataSource {
    //    pooled = true
    //    driverClassName = "com.mysql.jdbc.Driver"
    //    username = "root"
    //    password = "root"            
    pooled = true
    driverClassName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"
    username = "emorae"
    password = "s02257859"              
                    
}
hibernate {
    cache.use_second_level_cache = true
    cache.use_query_cache = false
    cache.region.factory_class = 'net.sf.ehcache.hibernate.EhCacheRegionFactory'
}
// environment specific settings
environments {
    development {
        dataSource {         
            //            dbCreate = "create" // one of 'create', 'create-drop','update'
            //            url = "jdbc:mysql://localhost:3306/bosanova_db?autoreconnect=true"           
            //            dialect = org.hibernate.dialect.MySQL5InnoDBDialect
            dbCreate = "update" // one of 'create', 'create-drop','update'                                
            url = "jdbc:sqlserver://168.176.36.26:1433;databaseName=dbd_1"            
            dialect = "org.hibernate.dialect.SQLServerDialect" 
                      
        }
        ////                dataSource_mysql {
        ////                    pooled = true
        ////                    driverClassName = "com.mysql.jdbc.Driver"
        ////                    username = "root"
        ////                    password = "root"            
        ////                    dbCreate = "update" // one of 'create', 'create-drop','update'
        ////                    url = "jdbc:mysql://localhost:3306/dbd_1"           
        ////                    dialect = org.hibernate.dialect.MySQL5InnoDBDialect
        ////                }
        //                dataSource_oracle {
        ////                    pooled = true
        ////                    driverClassName = "oracle.jdbc.driver.OracleDriver"
        ////                    username = "ehbuenoa"
        ////                    password = "s02257825"          
        ////                    dbCreate = "update" // one of 'create', 'create-drop','update'
        ////                    url = "jdbc:oracle:thin:@168.176.36.14:1521:UNBDS7"            
        ////                    dialect = "org.hibernate.dialect.Oracle10gDialect"
        //                }
        //                dataSource_sqlserver {
        //        pooled = true
        //        driverClassName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"
        //        username = "ehbuenoa"
        //        password = "s02257825"            
        //        dbCreate = "update" // one of 'create', 'create-drop','update'
        //        url = "jdbc:sqlserver://168.176.36.26:1433;databaseName=dbd_1"            
        //        dialect = "org.hibernate.dialect.SQLServerDialect"            
        //                }
        //                dataSource_sybase{
        ////                    pooled = true
        ////                    driverClassName = "com.sybase.jdbc3.jdbc.SybDataSource"
        ////                    username = "jrcuadradom"
        ////                    password = "s0225736"            
        ////                    dbCreate = "update" // one of 'create', 'create-drop','update'
        ////                    url = "jdbc:sybase:Tds:168.176.36.25:8101/dbd_1"            
        ////                    dialect = "org.hibernate.dialect.Sybase11Dialect"
        //                }
    }
    test {
    }
    production {
    }
}

